package com.truongnha.clienttn.data.dao;

import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

public class TeacherSubjectScheme {
	public static final String TABLE_NAME = "Teacher_subject";
	public static final String ID = "id";
	public static final String IS_COMMENT = "is_comment";
	public static final String CLASS_NAME = "class_name";
	public static final String HOME_TEACHER = "home_teacher";
	public static final String CLASS_ID = "class_id";
	public static final String SUBJECT = "subject";
	public static final String SIZE = "size";
	public static final String SUBJECT_ID = "subject_id";
	
	private static final String DATABASE_CREATE = "create table "
			+ TABLE_NAME + "(" 
			+ ID + " integer primary key  ,"  
			+ IS_COMMENT + " integer," 
			+ CLASS_NAME + " text, " 
			+ HOME_TEACHER + " text," 
			+ CLASS_ID + " interger," 
			+ SUBJECT + " text," 
			+ SIZE + " integer," 
			+ SUBJECT_ID + " integer" 
			+ " );";

	public static void onCreate(SQLiteDatabase db) {
		Log.i("LOG", "on Create account table");
		db.execSQL(DATABASE_CREATE);
	}
}
